The phrase "scary prospect" refers to something that is frightening or worrisome to think about or consider.